package com.whpost.service.dao.cwqf;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.whpost.service.entity.cwqf.VwKhqfSummary;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author YinZhuoyi
 * @since 2025-08-26
 */
public interface VwKhqfSummaryMapper extends BaseMapper<VwKhqfSummary> {

    //合计数字
    @Select("select sum(yqqf) as yqqf,sum(hj) as hj from vw_khqf_summary where rq >= TO_DATE(#{rq}, 'YYYY-MM-DD') AND rq < TO_DATE(#{rq}, 'YYYY-MM-DD')+1")
    List<Map<String, BigDecimal>> getHJ(String rq);

}
